CREATE TABLE `tb_users` (
  `id` int(11) NOT NULL auto_increment,
  `username` varchar(15) NOT NULL,
  `password` varchar(15) NOT NULL,
  `ip` varchar(15) NOT NULL,
  `email` varchar(150) NOT NULL,
  `pemail` varchar(150) NOT NULL,
  `referer` varchar(15) NOT NULL,
  `country` varchar(150) NOT NULL,
  `visits` varchar(150) NOT NULL default '0',
  `referals` varchar(150) NOT NULL default '0',
  `referalvisits` varchar(150) NOT NULL default '0',
  `money` varchar(150) NOT NULL default '0.00',
  `paid` varchar(150) NOT NULL default '0.00',
  `joindate` varchar(150) NOT NULL,
  `lastlogdate` varchar(150) NOT NULL,
  `lastiplog` varchar(150) NOT NULL,
  `account` varchar(150) NOT NULL,
  KEY `id` (`id`)
) ENGINE=MyISAM;


INSERT INTO `tb_users` VALUES (1, 'admin', '123456', '127.0.0.1', 'admin@admin.com', 'admin@admin.com', '', '0', '0', '0', '0', '0.00', '0.00', '1184512264', '1184575757', '127.0.0.1', '');


CREATE TABLE `tb_ads` (
  `id` int(11) NOT NULL auto_increment,
  `user` varchar(150) NOT NULL,
  `ip` varchar(15) NOT NULL,
  `tipo` varchar(150) NOT NULL,
  `visitime` varchar(150) NOT NULL,
  `ident` varchar(150) NOT NULL,
  `fechainicia` varchar(150) NOT NULL,
  `paypalname` varchar(150) NOT NULL,
  `paypalemail` varchar(150) NOT NULL,
  `plan` varchar(150) NOT NULL,
  `bold` varchar(150) NOT NULL,
  `highlight` varchar(150) NOT NULL,
  `url` varchar(150) NOT NULL,
  `description` varchar(150) NOT NULL,
  `category` varchar(150) NOT NULL,
  `members` varchar(150) NOT NULL default '0',
  `outside` varchar(150) NOT NULL default '0',
  `total` varchar(150) NOT NULL default '0',
  KEY `id` (`id`)
) ENGINE=MyISAM;

CREATE TABLE `tb_config` (
  `id` int(11) NOT NULL auto_increment,
  `item` varchar(15) NOT NULL,
  `howmany` varchar(15) NOT NULL,
  `price` varchar(150) NOT NULL,
  KEY `id` (`id`)
) ENGINE=MyISAM;

INSERT INTO `tb_config` VALUES (1, 'click', '1', '0.003');
INSERT INTO `tb_config` VALUES (1, 'referalclick', '1', '0.0015');
INSERT INTO `tb_config` VALUES (1, 'premiumclick', '1', '0.0034');
INSERT INTO `tb_config` VALUES (1, 'premiumreferalclick', '1', '0.0020');
INSERT INTO `tb_config` VALUES (1, 'hits', '1000', '5.00');
INSERT INTO `tb_config` VALUES (1, 'hits', '2000', '10.00');
INSERT INTO `tb_config` VALUES (1, 'hits', '3000', '15.00');
INSERT INTO `tb_config` VALUES (1, 'hits', '5000', '25.00');
INSERT INTO `tb_config` VALUES (1, 'hits', '10000', '50.00');
INSERT INTO `tb_config` VALUES (1, 'payment', '1', '10.00');
INSERT INTO `tb_config` VALUES (1, 'upgrade', '1', '29.99');


CREATE TABLE `tb_advertisers` (
  `id` int(11) NOT NULL auto_increment,
  `pname` varchar(150) NOT NULL,
  `pemail` varchar(150) NOT NULL,
  `plan` varchar(150) NOT NULL,
  `url` varchar(150) NOT NULL,
  `description` varchar(150) NOT NULL,
  `category` varchar(150) NOT NULL,
  `ip` varchar(15) NOT NULL,
  `bold` varchar(150) NOT NULL,
  `highlight` varchar(150) NOT NULL,
  `tipo` varchar(150) NOT NULL,
  `money` varchar(150) NOT NULL,
  KEY `id` (`id`)
) ENGINE=MyISAM;

CREATE TABLE `tb_contact` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(150) NOT NULL,
  `email` varchar(150) NOT NULL,
  `topic` varchar(150) NOT NULL,
  `subject` varchar(150) NOT NULL,
  `comments` varchar(200) NOT NULL,
  `ip` varchar(15) NOT NULL,
  KEY `id` (`id`)
) ENGINE=MyISAM;

CREATE TABLE `tb_payme` (
  `id` int(11) NOT NULL auto_increment,
  `username` varchar(150) NOT NULL,
  `pasword` varchar(150) NOT NULL,
  `email` varchar(150) NOT NULL,
  `pemail` varchar(150) NOT NULL,
  `country` varchar(150) NOT NULL,
  `money` varchar(150) NOT NULL,
  `ip` varchar(15) NOT NULL,
  KEY `id` (`id`)
) ENGINE=MyISAM;

CREATE TABLE `tb_buyref` (
  `id` int(11) NOT NULL auto_increment,
  `sets` varchar(150) NOT NULL,
  `customer` varchar(150) NOT NULL,
  `amount` varchar(150) NOT NULL,
  `pemail` varchar(150) NOT NULL,
  `ip` varchar(15) NOT NULL,
  KEY `id` (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;

INSERT INTO `tb_buyref` VALUES (1, '0', 'admin', '', '', '');

CREATE TABLE `tb_upgrade` (
  `id` int(11) NOT NULL auto_increment,
  `username` varchar(150) NOT NULL,
  `pemail` varchar(150) NOT NULL,
  `email` varchar(150) NOT NULL,
  `status` varchar(150) NOT NULL,
  `date` varchar(150) NOT NULL,
  `ip` varchar(15) NOT NULL,
  KEY `id` (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;

CREATE TABLE `tb_history` (
  `id` int(11) NOT NULL auto_increment,
  `user` varchar(150) NOT NULL,
  `date` varchar(150) NOT NULL,
  `amount` varchar(150) NOT NULL,
  `method` varchar(150) NOT NULL,
  `status` varchar(150) NOT NULL,
  KEY `id` (`id`)
) ENGINE=MyISAM;

